How to make if else Condition in Adv. SQL Query?

Hello Roshan,

The CASE condition would be a good choice for your requirement. Regarding your note, you don't have to worry about data types if your HomeZipCode output structure has an attribute of type Text - if you try to store an Integer in it, it will be implicitly converted to a string.

I don't know what error you're receiving, but I suspect the issue is that a CASE can only return one datatype (or multiple datatypes if they can be implicitly converted). So this will return an error, because it will return a string or an integer:

but this will not, since it only returns strings:

All you need to do is convert or cast your HomeZipCode into a String in the CASE branch, something like this:

and since your CASE now only returns strings, you shouldn't receive any errors.